IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SrvrInstncDatabaseFileMSSQL]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[SrvrInstncDatabaseFileMSSQL]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SrvrInstncDatabaseFileMSSQL](
     [SrvrInstncDatabaseFileMSSQLId] [int]              NOT NULL,
     [SrvrInstncDatabaseId]          [int]              NOT NULL,
     [PackageExecutionId]            [bigint]           NOT NULL,
     [StartDt]                       [datetime]         NOT NULL,
     [EndDt]                         [datetime]         NOT NULL,
     [CurrentRecordFlag]             [tinyint]          NOT NULL CONSTRAINT [DF_SrvrInstncDatabaseFileMSSQL_CurrentRecordFlag] DEFAULT ((0)),
     [FileDeletedFlag]               [tinyint]          NOT NULL CONSTRAINT [DF_SrvrInstncDatabaseFileMSSQL_FileDeletedFlag] DEFAULT ((0)),
     [DatabaseFileId]                [int]                  NULL,
     [DatabaseFileGUID]              [uniqueidentifier]     NULL,
     [FileIsLogFileFlag]             [tinyint]              NULL,
     [FileSizeInMB]                  [int]              NOT NULL,
     [MaxFileSizeInMB]               [int]                  NULL,
     [FileGrowthInMB]                [int]                  NULL,
     [FileGrowthInPct]               [tinyint]              NULL,
     [FileGroupName]                 [varchar](128)         NULL,
     [LogicalFileName]               [varchar](128)         NULL,
     [PhysicalFileNameWithPath]      [varchar](255)         NULL,
     CONSTRAINT [PK_SrvrInstncDatabaseFileMSSQL] PRIMARY KEY CLUSTERED ( [SrvrInstncDatabaseFileMSSQLId] ASC, [SrvrInstncDatabaseId] ASC, [StartDt] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO
